/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : PostgreSQL
 Source Server Version : 90503
 Source Host           : localhost
 Source Database       : ass
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 90503
 File Encoding         : utf-8

 Date: 06/10/2018 20:57:34 PM
*/

-- ----------------------------
--  Table structure for t_market_keyword
-- ----------------------------
DROP TABLE IF EXISTS "public"."t_market_keyword";
CREATE TABLE "public"."t_market_keyword" (
	"id" int4 NOT NULL DEFAULT nextval('t_market_keyword_id_seq'::regclass),
	"name" varchar NOT NULL COLLATE "default",
	"pos" int4 NOT NULL
)
WITH (OIDS=FALSE);
ALTER TABLE "public"."t_market_keyword" OWNER TO "postgres";

COMMENT ON TABLE "public"."t_market_keyword" IS '行情关键字表';

-- ----------------------------
--  Records of t_market_keyword
-- ----------------------------
BEGIN;
INSERT INTO "public"."t_market_keyword" VALUES ('1', '今日开盘价', '1');
INSERT INTO "public"."t_market_keyword" VALUES ('2', '昨日收盘价', '2');
INSERT INTO "public"."t_market_keyword" VALUES ('3', '当前价格', '3');
INSERT INTO "public"."t_market_keyword" VALUES ('4', '今日最高价', '4');
INSERT INTO "public"."t_market_keyword" VALUES ('5', '今日最低价', '5');
INSERT INTO "public"."t_market_keyword" VALUES ('6', '竞买价', '6');
INSERT INTO "public"."t_market_keyword" VALUES ('7', '竞卖价', '7');
INSERT INTO "public"."t_market_keyword" VALUES ('8', '成交股数', '8');
INSERT INTO "public"."t_market_keyword" VALUES ('9', '成交金额', '9');
INSERT INTO "public"."t_market_keyword" VALUES ('16', '买1手', '10');
INSERT INTO "public"."t_market_keyword" VALUES ('17', '买1价', '11');
INSERT INTO "public"."t_market_keyword" VALUES ('18', '买2手', '12');
INSERT INTO "public"."t_market_keyword" VALUES ('19', '买2价', '13');
INSERT INTO "public"."t_market_keyword" VALUES ('20', '买3手', '14');
INSERT INTO "public"."t_market_keyword" VALUES ('21', '买3价', '15');
INSERT INTO "public"."t_market_keyword" VALUES ('22', '买4手', '16');
INSERT INTO "public"."t_market_keyword" VALUES ('23', '买4价', '17');
INSERT INTO "public"."t_market_keyword" VALUES ('24', '买5手', '18');
INSERT INTO "public"."t_market_keyword" VALUES ('25', '买5价', '19');
INSERT INTO "public"."t_market_keyword" VALUES ('26', '卖1手', '20');
INSERT INTO "public"."t_market_keyword" VALUES ('27', '卖1价', '21');
INSERT INTO "public"."t_market_keyword" VALUES ('28', '卖2手', '22');
INSERT INTO "public"."t_market_keyword" VALUES ('29', '卖2价', '23');
INSERT INTO "public"."t_market_keyword" VALUES ('30', '卖3手', '24');
INSERT INTO "public"."t_market_keyword" VALUES ('31', '卖3价', '25');
INSERT INTO "public"."t_market_keyword" VALUES ('32', '卖4手', '26');
INSERT INTO "public"."t_market_keyword" VALUES ('33', '卖4价', '27');
INSERT INTO "public"."t_market_keyword" VALUES ('34', '卖5手', '28');
INSERT INTO "public"."t_market_keyword" VALUES ('35', '卖5价', '29');
INSERT INTO "public"."t_market_keyword" VALUES ('36', '日期', '30');
INSERT INTO "public"."t_market_keyword" VALUES ('37', '时间', '31');
COMMIT;

-- ----------------------------
--  Primary key structure for table t_market_keyword
-- ----------------------------
ALTER TABLE "public"."t_market_keyword" ADD PRIMARY KEY ("id") NOT DEFERRABLE INITIALLY IMMEDIATE;

